﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsAdminitracao" targetNamespace="http://tempuri.org/dsAdminitracao.xsd" xmlns:mstns="http://tempuri.org/dsAdminitracao.xsd" xmlns="http://tempuri.org/dsAdminitracao.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="SamecaGestConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SamecaGestConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.SamecaGestV2.My.MySettings.GlobalReference.Default.SamecaGestConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblEmpresaTableAdapter" GeneratorDataComponentClassName="tblEmpresaTableAdapter" Name="tblEmpresa" UserDataComponentName="tblEmpresaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SamecaGestConnectionString (MySettings)" DbObjectName="SamecaGest.dbo.tblEmpresa" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblEmpresa] WHERE (([Empresa] = @Original_Empresa) AND ((@IsNull_EmpresaDesc = 1 AND [EmpresaDesc] IS NULL) OR ([EmpresaDesc] = @Original_EmpresaDesc)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Empresa" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Empresa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmpresaDesc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmpresaDesc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EmpresaDesc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmpresaDesc" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblEmpresa] ([Empresa], [EmpresaDesc]) VALUES (@Empresa, @EmpresaDesc);
SELECT Empresa, EmpresaDesc FROM tblEmpresa WHERE (Empresa = @Empresa)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Empresa" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Empresa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmpresaDesc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmpresaDesc" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Empresa, EmpresaDesc
FROM            tblEmpresa</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblEmpresa] SET [Empresa] = @Empresa, [EmpresaDesc] = @EmpresaDesc WHERE (([Empresa] = @Original_Empresa) AND ((@IsNull_EmpresaDesc = 1 AND [EmpresaDesc] IS NULL) OR ([EmpresaDesc] = @Original_EmpresaDesc)));
SELECT Empresa, EmpresaDesc FROM tblEmpresa WHERE (Empresa = @Empresa)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Empresa" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Empresa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmpresaDesc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmpresaDesc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Empresa" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Empresa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmpresaDesc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EmpresaDesc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EmpresaDesc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmpresaDesc" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Empresa" DataSetColumn="Empresa" />
              <Mapping SourceColumn="EmpresaDesc" DataSetColumn="EmpresaDesc" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SamecaGestConnectionString (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       tblEmpresa
SET                EmpresaDesc = @EmpresaDesc
WHERE        (Empresa = @Empresa);   
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="EmpresaDesc" ColumnName="EmpresaDesc" DataSourceName="SamecaGest.dbo.tblEmpresa" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@EmpresaDesc" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="EmpresaDesc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Empresa" ColumnName="Empresa" DataSourceName="SamecaGest.dbo.tblEmpresa" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@Empresa" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="Empresa" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblUserConfigTableAdapter" GeneratorDataComponentClassName="tblUserConfigTableAdapter" Name="tblUserConfig" UserDataComponentName="tblUserConfigTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SamecaGestConnectionString (MySettings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblUsers.UserName, tblUsers.Pass, tblUsers.EmpresaDefault, tblUserGrpMap.GroupCode, tblUsers.PrimeiroNome, tblUsers.UltimoNome, 
                         tblUsers.Email
FROM            tblGruposAcessoDesc INNER JOIN
                         tblUserGrpMap ON tblGruposAcessoDesc.GroupCode = tblUserGrpMap.GroupCode RIGHT OUTER JOIN
                         tblUsers ON tblUserGrpMap.UserId = tblUsers.UserName</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
              <Mapping SourceColumn="Pass" DataSetColumn="Pass" />
              <Mapping SourceColumn="EmpresaDefault" DataSetColumn="EmpresaDefault" />
              <Mapping SourceColumn="GroupCode" DataSetColumn="GroupCode" />
              <Mapping SourceColumn="PrimeiroNome" DataSetColumn="PrimeiroNome" />
              <Mapping SourceColumn="UltimoNome" DataSetColumn="UltimoNome" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblGruposAcessoDescTableAdapter" GeneratorDataComponentClassName="tblGruposAcessoDescTableAdapter" Name="tblGruposAcessoDesc" UserDataComponentName="tblGruposAcessoDescTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SamecaGestConnectionString (MySettings)" DbObjectName="SamecaGest.dbo.tblGruposAcessoDesc" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblGruposAcessoDesc] WHERE (([GroupCode] = @Original_GroupCode) AND ((@IsNull_GroupDesc = 1 AND [GroupDesc] IS NULL) OR ([GroupDesc] = @Original_GroupDesc)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_GroupCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GroupCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GroupDesc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GroupDesc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_GroupDesc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GroupDesc" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblGruposAcessoDesc] ([GroupCode], [GroupDesc]) VALUES (@GroupCode, @GroupDesc);
SELECT GroupCode, GroupDesc FROM tblGruposAcessoDesc WHERE (GroupCode = @GroupCode)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GroupCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GroupCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@GroupDesc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GroupDesc" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        GroupCode, GroupDesc
FROM            tblGruposAcessoDesc</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblGruposAcessoDesc] SET [GroupCode] = @GroupCode, [GroupDesc] = @GroupDesc WHERE (([GroupCode] = @Original_GroupCode) AND ((@IsNull_GroupDesc = 1 AND [GroupDesc] IS NULL) OR ([GroupDesc] = @Original_GroupDesc)));
SELECT GroupCode, GroupDesc FROM tblGruposAcessoDesc WHERE (GroupCode = @GroupCode)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GroupCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GroupCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@GroupDesc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GroupDesc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_GroupCode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GroupCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GroupDesc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GroupDesc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_GroupDesc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GroupDesc" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="GroupCode" DataSetColumn="GroupCode" />
              <Mapping SourceColumn="GroupDesc" DataSetColumn="GroupDesc" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsAdminitracao" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsAdminitracao" msprop:Generator_UserDSName="dsAdminitracao">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblEmpresa" msprop:Generator_TableClassName="tblEmpresaDataTable" msprop:Generator_TableVarName="tabletblEmpresa" msprop:Generator_TablePropName="tblEmpresa" msprop:Generator_RowDeletingName="tblEmpresaRowDeleting" msprop:Generator_RowChangingName="tblEmpresaRowChanging" msprop:Generator_RowEvHandlerName="tblEmpresaRowChangeEventHandler" msprop:Generator_RowDeletedName="tblEmpresaRowDeleted" msprop:Generator_UserTableName="tblEmpresa" msprop:Generator_RowChangedName="tblEmpresaRowChanged" msprop:Generator_RowEvArgName="tblEmpresaRowChangeEvent" msprop:Generator_RowClassName="tblEmpresaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Empresa" msprop:Generator_ColumnVarNameInTable="columnEmpresa" msprop:Generator_ColumnPropNameInRow="Empresa" msprop:Generator_ColumnPropNameInTable="EmpresaColumn" msprop:Generator_UserColumnName="Empresa">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmpresaDesc" msprop:Generator_ColumnVarNameInTable="columnEmpresaDesc" msprop:Generator_ColumnPropNameInRow="EmpresaDesc" msprop:Generator_ColumnPropNameInTable="EmpresaDescColumn" msprop:Generator_UserColumnName="EmpresaDesc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblUserConfig" msprop:Generator_TableClassName="tblUserConfigDataTable" msprop:Generator_TableVarName="tabletblUserConfig" msprop:Generator_TablePropName="tblUserConfig" msprop:Generator_RowDeletingName="tblUserConfigRowDeleting" msprop:Generator_RowChangingName="tblUserConfigRowChanging" msprop:Generator_RowEvHandlerName="tblUserConfigRowChangeEventHandler" msprop:Generator_RowDeletedName="tblUserConfigRowDeleted" msprop:Generator_UserTableName="tblUserConfig" msprop:Generator_RowChangedName="tblUserConfigRowChanged" msprop:Generator_RowEvArgName="tblUserConfigRowChangeEvent" msprop:Generator_RowClassName="tblUserConfigRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Pass" msprop:Generator_ColumnVarNameInTable="columnPass" msprop:Generator_ColumnPropNameInRow="Pass" msprop:Generator_ColumnPropNameInTable="PassColumn" msprop:Generator_UserColumnName="Pass" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EmpresaDefault" msprop:Generator_ColumnVarNameInTable="columnEmpresaDefault" msprop:Generator_ColumnPropNameInRow="EmpresaDefault" msprop:Generator_ColumnPropNameInTable="EmpresaDefaultColumn" msprop:Generator_UserColumnName="EmpresaDefault" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GroupCode" msprop:Generator_ColumnVarNameInTable="columnGroupCode" msprop:Generator_ColumnPropNameInRow="GroupCode" msprop:Generator_ColumnPropNameInTable="GroupCodeColumn" msprop:Generator_UserColumnName="GroupCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PrimeiroNome" msprop:Generator_ColumnVarNameInTable="columnPrimeiroNome" msprop:Generator_ColumnPropNameInRow="PrimeiroNome" msprop:Generator_ColumnPropNameInTable="PrimeiroNomeColumn" msprop:Generator_UserColumnName="PrimeiroNome" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UltimoNome" msprop:Generator_ColumnVarNameInTable="columnUltimoNome" msprop:Generator_ColumnPropNameInRow="UltimoNome" msprop:Generator_ColumnPropNameInTable="UltimoNomeColumn" msprop:Generator_UserColumnName="UltimoNome" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblGruposAcessoDesc" msprop:Generator_TableClassName="tblGruposAcessoDescDataTable" msprop:Generator_TableVarName="tabletblGruposAcessoDesc" msprop:Generator_TablePropName="tblGruposAcessoDesc" msprop:Generator_RowDeletingName="tblGruposAcessoDescRowDeleting" msprop:Generator_RowChangingName="tblGruposAcessoDescRowChanging" msprop:Generator_RowEvHandlerName="tblGruposAcessoDescRowChangeEventHandler" msprop:Generator_RowDeletedName="tblGruposAcessoDescRowDeleted" msprop:Generator_UserTableName="tblGruposAcessoDesc" msprop:Generator_RowChangedName="tblGruposAcessoDescRowChanged" msprop:Generator_RowEvArgName="tblGruposAcessoDescRowChangeEvent" msprop:Generator_RowClassName="tblGruposAcessoDescRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="GroupCode" msprop:Generator_ColumnVarNameInTable="columnGroupCode" msprop:Generator_ColumnPropNameInRow="GroupCode" msprop:Generator_ColumnPropNameInTable="GroupCodeColumn" msprop:Generator_UserColumnName="GroupCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GroupDesc" msprop:Generator_ColumnVarNameInTable="columnGroupDesc" msprop:Generator_ColumnPropNameInRow="GroupDesc" msprop:Generator_ColumnPropNameInTable="GroupDescColumn" msprop:Generator_UserColumnName="GroupDesc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblEmpresa" />
      <xs:field xpath="mstns:Empresa" />
    </xs:unique>
    <xs:unique name="tblUserConfig_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblUserConfig" />
      <xs:field xpath="mstns:UserName" />
    </xs:unique>
    <xs:unique name="tblGruposAcessoDesc_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblGruposAcessoDesc" />
      <xs:field xpath="mstns:GroupCode" />
    </xs:unique>
  </xs:element>
</xs:schema>